CREATE TABLE [dbo].[GRNVoid]
(
[GRNId] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidReason] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidPerson] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidDate] [datetime] NOT NULL CONSTRAINT [DF_GRNVoid_VoidDate] DEFAULT (getdate()),
[Remark] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GRNVoid] ADD CONSTRAINT [PK_GRNVoid] PRIMARY KEY CLUSTERED  ([GRNId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GRNVoid] ADD CONSTRAINT [FK_GRNVoid_GRN] FOREIGN KEY ([GRNId]) REFERENCES [dbo].[GRN] ([GRNId])
GO
